<?php
/* -----------------------------------------------------------------
 *                        Aveghe My Blog
 * -----------------------------------------------------------------
 * Aveghe My Blog: made your blog easy!
 * Copyright (C) 2008 Elia Contini
 * 
 * Aveghe My Blog is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 * 
 * Aveghe My Blog is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA 02110-1301, USA.
 */

class Preference
	{
		private $db;
		private $tablePrefix;
		
		public function __construct()
			{
				$this->db = Zend_Registry::get('db');
				$this->tablePrefix =  Zend_Registry::get('tablePrefix');
			}
			
		public function getAll()
			{
				$sql = 'SELECT * FROM '.$this->tablePrefix.'preferences';
				$row = $this->db->fetchRow($sql);

				return $row;
			}
			
		public function getPreference($key)
			{
				$sql = 'SELECT '.$key.' FROM '.$this->tablePrefix.'preferences';
				$row = $this->db->fetchRow($sql);

				return $row[$key];
			}
			
		public function insertUpdateComment($preferenceData)
			{
				
						
						/*while(list($key, $value) = each($comment))
							echo "$key : $value <br />"; die;*/
						
						$this->db->update($this->tablePrefix.'preferences', $preferenceData);
					
			}
	}
?>